[dbo].[asi_GroupActiveMemberKeyByGroupRole]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_GroupActiveMemberKeyByGroupRole

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@groupKey	uniqueidentifier	16
@roleKey	uniqueidentifier	16

SQL Script

CREATE PROCEDURE [dbo].[asi_GroupActiveMemberKeyByGroupRole] (@groupKey uniqueidentifier, @roleKey uniqueidentifier)
AS
BEGIN

SELECT gm.GroupMemberKey, gm.MemberContactKey
FROM GroupMember gm INNER JOIN GroupMemberDetail gmd ON gm.GroupMemberKey = gmd.GroupMemberKey
WHERE gm.GroupKey=@groupKey AND gmd.GroupRoleKey=@roleKey AND gmd.IsActive = 1
ORDER BY gmd.EffectiveDate

END

GO

Uses

[dbo].[GroupMember]
[dbo].[GroupMemberDetail]
dbo